interview

home / developersection / interviews / how to update only a specific field in a record?

Ask Question
Jiva Ram

Student

I am the only man in my village who has completed his education, and that fact carries both pride and responsibility. Coming from a remote rural area where education is often overlooked in favor of traditional labor, my journey was anything but easy.

Follow
Can you answer this question?
Answer

1 Answers

Jiva Ram

Jiva Ram

30-Jun-2025

To update a specific field in a record in IndexedDB, follow this common pattern:

  • Get the record by key (get()).
  • Modify the specific field.
  • Put the updated record back using put().

IndexedDB doesn't support partial updates directly — so you need to overwrite the whole object after changing just the part you want.

Example: Update a Specific Field

Suppose we have a Users object store with this record:

{ id: 1, name: "John", email: "john@example.com", age: 30 }

Now we want to update only the email field.

Function to Update One Field

function updateField(db, storeName, key, fieldName, newValue) {
    return new Promise((resolve, reject) => {
        const tx = db.transaction(storeName, 'readwrite');
        const store = tx.objectStore(storeName);

        const getRequest = store.get(key);

        getRequest.onsuccess = () => {
            const record = getRequest.result;

            if (!record) {
                reject('Record not found');
                return;
            }

            // Update the specific field
            record[fieldName] = newValue;

            const updateRequest = store.put(record);

            updateRequest.onsuccess = () => resolve('Field updated');
            updateRequest.onerror = (e) => reject(`Update error: ${e.target.errorCode}`);
        };

        getRequest.onerror = (e) => reject(`Get error: ${e.target.errorCode}`);
    });
}

Usage

(async () => {
    const db = await openDatabase('MyDB', 'Users'); // use the openDatabase function from earlier

    try {
        await updateField(db, 'Users', 1, 'email', 'new.email@example.com');
        console.log('Email updated!');
    } catch (err) {
        console.error(err);
    }
})();

Tip: Batch Field Updates

To update multiple fields:

Object.assign(record, { email: 'new@email.com', age: 31 });

Summary

  • You must fetch the full object, update the field(s), then overwrite it with put().
  • IndexedDB doesn’t support in-place field updates (like SQL’s UPDATE ... SET ...).
  • Use get(), modify, and put() for partial updates.
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy